﻿using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace ECCSystem.DataAccess
{ 
    class ClsDeleteHistoryData:DBObject 
    {
        public ClsDeleteHistoryData()
        { }

        public int DeleteHistoryData(DateTime dtStartDate,DateTime dtEndDate)
        {
            int intRowsAffected=0;
            SqlParameter[] patameters = new SqlParameter[] {new SqlParameter("@StartDate",SqlDbType.NVarChar,20),
                                                new SqlParameter("@EndDate",SqlDbType.NVarChar,20)};
            patameters[0].Value = dtStartDate.Date.ToString("yyyy/MM/dd");
            patameters[1].Value = dtEndDate.Date.ToString("yyyy/MM/dd");
            return this.RunProcedure("sp_BusinessInfo_DeleteHistory", patameters, ref intRowsAffected);
        }
    }
}
